<?php

namespace Database\Seeders;

use Illuminate\Database\Console\Seeds\WithoutModelEvents;
use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;

class MusicTypeMenuSeeder extends Seeder
{
    /**
     * Run the database seeds.
     */
    public function run(): void
    {
        $nowDate = date('Y-m-d H:m:s', time());
        $sql = "insert into music_type_menus values (?,?,?,?,?,?,?,?,?)";
        DB::insert($sql, [null, 1, '歌词', '歌词', 1, null, $nowDate, $nowDate, null]);
        DB::insert($sql, [null, 1, '伴奏', '伴奏', 2, null, $nowDate, $nowDate, null]);
        DB::insert($sql, [null, 1, '男调', '男调', 3, null, $nowDate, $nowDate, null]);
        DB::insert($sql, [null, 1, '女调', '女调', 4, null, $nowDate, $nowDate, null]);

        DB::insert($sql, [null, 2, '识谱', '识谱', 1, null, $nowDate, $nowDate, null]);
        DB::insert($sql, [null, 2, '伴奏', '伴奏', 2, null, $nowDate, $nowDate, null]);
        DB::insert($sql, [null, 2, 'C调', 'C调', 3, null, $nowDate, $nowDate, null]);
        DB::insert($sql, [null, 2, 'G调', 'G调', 4, null, $nowDate, $nowDate, null]);
        DB::insert($sql, [null, 2, 'F调', 'F调', 5, null, $nowDate, $nowDate, null]);
        DB::insert($sql, [null, 2, 'bB调', 'bB调', 6, null, $nowDate, $nowDate, null]);
        DB::insert($sql, [null, 2, 'D调', 'D调', 7, null, $nowDate, $nowDate, null]);


        DB::insert($sql, [null, 3, '合唱', '合唱', 1, null, $nowDate, $nowDate, null]);
        DB::insert($sql, [null, 3, '钢琴', '钢琴', 2, null, $nowDate, $nowDate, null]);
        DB::insert($sql, [null, 3, '一声部', '一声部', 3, null, $nowDate, $nowDate, null]);
        DB::insert($sql, [null, 3, '二声部', '二声部', 4, null, $nowDate, $nowDate, null]);
        DB::insert($sql, [null, 3, '三声部', '三声部', 5, null, $nowDate, $nowDate, null]);
        DB::insert($sql, [null, 3, '四声部', '四声部', 6, null, $nowDate, $nowDate, null]);
        DB::insert($sql, [null, 3, '和声合唱', '和声合唱', 7, null, $nowDate, $nowDate, null]);
        DB::insert($sql, [null, 3, '钢琴合手', '钢琴合手', 8, null, $nowDate, $nowDate, null]);

        DB::insert($sql, [null, 5, '人声带视唱', '人声带视唱', 1, null, $nowDate, $nowDate, null]);
        DB::insert($sql, [null, 5, '钢琴主旋律', '钢琴主旋律', 2, null, $nowDate, $nowDate, null]);
        DB::insert($sql, [null, 5, '无旋律伴奏', '无旋律伴奏', 3, null, $nowDate, $nowDate, null]);


    }
}
